Pandas Profiling Report

Dataset statistics

Number of variables	31
Number of observations	142999
Missing cells	52
Missing cells (%)	< 0.1%
Duplicate rows	3
Duplicate rows (%)	< 0.1%
Total size in memory	162.4 MiB
Average record size in memory	1.2 KiB

Variable types

Categorical	17
DateTime	4
Numeric	9
Unsupported	1

Warnings

`City` has constant value "Palo Alto"	Constant
`State/Province` has constant value "California"	Constant
`Country` has constant value "United States"	Constant
Dataset has 3 (< 0.1%) duplicate rows	Duplicates
`MAC Address` has a high cardinality: 55 distinct values	High cardinality
`Park Duration (mins)` has a high cardinality: 1217 distinct values	High cardinality
`Energy (kWh)` is highly correlated with `GHG Savings (kg)` and 1 other fields	High correlation
`GHG Savings (kg)` is highly correlated with `Energy (kWh)` and 1 other fields	High correlation
`Gasoline Savings (gallons)` is highly correlated with `Energy (kWh)` and 1 other fields	High correlation
`Plug Type` is highly correlated with `Country` and 3 other fields	High correlation
`Address 1` is highly correlated with `Postal Code` and 3 other fields	High correlation
`Port Number` is highly correlated with `Country` and 2 other fields	High correlation
`Postal Code` is highly correlated with `Address 1` and 6 other fields	High correlation
`Org Name` is highly correlated with `Country` and 2 other fields	High correlation
`Country` is highly correlated with `Plug Type` and 14 other fields	High correlation
`Ended By` is highly correlated with `Country` and 2 other fields	High correlation
`Start Time Zone` is highly correlated with `Country` and 2 other fields	High correlation
`MAC Address` is highly correlated with `Postal Code` and 4 other fields	High correlation
`City` is highly correlated with `Plug Type` and 14 other fields	High correlation
`State/Province` is highly correlated with `Plug Type` and 14 other fields	High correlation
`Currency` is highly correlated with `Country` and 2 other fields	High correlation
`Station Name` is highly correlated with `Postal Code` and 5 other fields	High correlation
`End Time Zone` is highly correlated with `Country` and 2 other fields	High correlation
`Pairlocation` is highly correlated with `Postal Code` and 4 other fields	High correlation
`Port Type` is highly correlated with `Plug Type` and 3 other fields	High correlation
`Driver Postal Code` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Fee` has 127421 (89.1%) zeros	Zeros
`ID` has 10712 (7.5%) zeros	Zeros

Reproduction

Analysis started	2021-02-10 09:40:09.479774
Analysis finished	2021-02-10 09:40:58.675659
Duration	49.2 seconds
Software version	pandas-profiling v2.10.1
Download configuration	config.yaml

Station Name
Categorical

HIGH CORRELATION

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.2 MiB

PALO ALTO CA / HAMILTON #2	14090
PALO ALTO CA / BRYANT #2	11672
PALO ALTO CA / BRYANT #1	10909
PALO ALTO CA / HAMILTON #1	10712
PALO ALTO CA / HIGH #4	10050
Other values (22)	85566

Length

Max length	30
Median length	25
Mean length	24.81857216
Min length	21

Characters and Unicode

Total characters	3549031
Distinct characters	27
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PALO ALTO CA / HAMILTON #1
2nd row	PALO ALTO CA / HAMILTON #1
3rd row	PALO ALTO CA / HAMILTON #1
4th row	PALO ALTO CA / HAMILTON #1
5th row	PALO ALTO CA / HAMILTON #1

Value	Count	Frequency (%)
PALO ALTO CA / HAMILTON #2	14090	9.9%
PALO ALTO CA / BRYANT #2	11672	8.2%
PALO ALTO CA / BRYANT #1	10909	7.6%
PALO ALTO CA / HAMILTON #1	10712	7.5%
PALO ALTO CA / HIGH #4	10050	7.0%
PALO ALTO CA / WEBSTER #1	7760	5.4%
PALO ALTO CA / WEBSTER #2	7296	5.1%
PALO ALTO CA / HIGH #1	6756	4.7%
PALO ALTO CA / WEBSTER #3	5827	4.1%
PALO ALTO CA / CAMBRIDGE #1	5721	4.0%
Other values (17)	52206	36.5%

Histogram of lengths of the category

Value	Count	Frequency (%)
	142999	16.3%
alto	142999	16.3%
palo	142999	16.3%
ca	142999	16.3%
1	52739	6.0%
2	46129	5.3%
bryant	27693	3.2%
hamilton	24802	2.8%
high	21683	2.5%
webster	20883	2.4%
Other values (10)	110609	12.6%

Most occurring characters

Value	Count	Frequency (%)
	733535	20.7%
A	518756	14.6%
L	342108	9.6%
O	334822	9.4%
T	227341	6.4%
C	167205	4.7%
P	166731	4.7%
/	142999	4.0%
#	129941	3.7%
N	84093	2.4%
Other values (17)	701500	19.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2399557	67.6%
Space Separator	733535	20.7%
Other Punctuation	272940	7.7%
Decimal Number	142999	4.0%

Most frequent character per category

Value	Count	Frequency (%)
A	518756	21.6%
L	342108	14.3%
O	334822	14.0%
T	227341	9.5%
C	167205	7.0%
P	166731	6.9%
N	84093	3.5%
I	83749	3.5%
H	73650	3.1%
B	72782	3.0%
Other values (8)	328320	13.7%

Value	Count	Frequency (%)
1	52739	36.9%
2	46129	32.3%
3	16838	11.8%
4	15351	10.7%
6	6318	4.4%
5	5624	3.9%

Value	Count	Frequency (%)
/	142999	52.4%
#	129941	47.6%

Value	Count	Frequency (%)
	733535	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2399557	67.6%
Common	1149474	32.4%

Most frequent character per script

Value	Count	Frequency (%)
A	518756	21.6%
L	342108	14.3%
O	334822	14.0%
T	227341	9.5%
C	167205	7.0%
P	166731	6.9%
N	84093	3.5%
I	83749	3.5%
H	73650	3.1%
B	72782	3.0%
Other values (8)	328320	13.7%

Value	Count	Frequency (%)
	733535	63.8%
/	142999	12.4%
#	129941	11.3%
1	52739	4.6%
2	46129	4.0%
3	16838	1.5%
4	15351	1.3%
6	6318	0.5%
5	5624	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3549031	100.0%

Most frequent character per block

Value	Count	Frequency (%)
	733535	20.7%
A	518756	14.6%
L	342108	9.6%
O	334822	9.4%
T	227341	6.4%
C	167205	4.7%
P	166731	4.7%
/	142999	4.0%
#	129941	3.7%
N	84093	2.4%
Other values (17)	701500	19.8%

MAC Address
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	55
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

000D:6F00:015A:9D76	10712
000D:6F00:009E:D39E	9759
000D6F0000A20D9E	7866
000D6F0000A20F47	6820
0024:B100:0002:1331	5871
Other values (50)	101971

Length

Max length	19
Median length	19
Mean length	18.25683396
Min length	16

Characters and Unicode

Total characters	2610709
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	000D:6F00:015A:9D76
2nd row	000D:6F00:015A:9D76
3rd row	000D:6F00:015A:9D76
4th row	000D:6F00:015A:9D76
5th row	000D:6F00:015A:9D76

Value	Count	Frequency (%)
000D:6F00:015A:9D76	10712	7.5%
000D:6F00:009E:D39E	9759	6.8%
000D6F0000A20D9E	7866	5.5%
000D6F0000A20F47	6820	4.8%
0024:B100:0002:1331	5871	4.1%
0024:B100:0002:1329	5721	4.0%
0024:B100:0002:10FE	5544	3.9%
0024:B100:0002:1323	5482	3.8%
000D6F00009DCFC3	5477	3.8%
0024:B100:0002:13B7	5427	3.8%
Other values (45)	74320	52.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
000d:6f00:015a:9d76	10712	7.5%
000d:6f00:009e:d39e	9759	6.8%
000d6f0000a20d9e	7866	5.5%
000d6f0000a20f47	6820	4.8%
0024:b100:0002:1331	5871	4.1%
0024:b100:0002:1329	5721	4.0%
0024:b100:0002:10fe	5544	3.9%
0024:b100:0002:1323	5482	3.8%
000d6f00009dcfc3	5477	3.8%
0024:b100:0002:13b7	5427	3.8%
Other values (45)	74320	52.0%

Most occurring characters

Value	Count	Frequency (%)
0	1008170	38.6%
:	322725	12.4%
2	166042	6.4%
1	159720	6.1%
D	140007	5.4%
F	126407	4.8%
6	110250	4.2%
4	94467	3.6%
9	91721	3.5%
B	86730	3.3%
Other values (7)	304470	11.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1805216	69.1%
Uppercase Letter	482768	18.5%
Other Punctuation	322725	12.4%

Most frequent character per category

Value	Count	Frequency (%)
0	1008170	55.8%
2	166042	9.2%
1	159720	8.8%
6	110250	6.1%
4	94467	5.2%
9	91721	5.1%
3	65483	3.6%
5	51288	2.8%
7	46428	2.6%
8	11647	0.6%

Value	Count	Frequency (%)
D	140007	29.0%
F	126407	26.2%
B	86730	18.0%
A	49670	10.3%
E	48398	10.0%
C	31556	6.5%

Value	Count	Frequency (%)
:	322725	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2127941	81.5%
Latin	482768	18.5%

Most frequent character per script

Value	Count	Frequency (%)
0	1008170	47.4%
:	322725	15.2%
2	166042	7.8%
1	159720	7.5%
6	110250	5.2%
4	94467	4.4%
9	91721	4.3%
3	65483	3.1%
5	51288	2.4%
7	46428	2.2%

Value	Count	Frequency (%)
D	140007	29.0%
F	126407	26.2%
B	86730	18.0%
A	49670	10.3%
E	48398	10.0%
C	31556	6.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2610709	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	1008170	38.6%
:	322725	12.4%
2	166042	6.4%
1	159720	6.1%
D	140007	5.4%
F	126407	4.8%
6	110250	4.2%
4	94467	3.6%
9	91721	3.5%
B	86730	3.3%
Other values (7)	304470	11.7%

Org Name
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.2 MiB

City of Palo Alto	122352
City of Palo Alto	20647

Length

Max length	18
Median length	18
Mean length	17.85561437
Min length	17

Characters and Unicode

Total characters	2553335
Distinct characters	11
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	City of Palo Alto
2nd row	City of Palo Alto
3rd row	City of Palo Alto
4th row	City of Palo Alto
5th row	City of Palo Alto

Value	Count	Frequency (%)
City of Palo Alto	122352	85.6%
City of Palo Alto	20647	14.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
palo	142999	25.0%
of	142999	25.0%
alto	142999	25.0%
city	142999	25.0%

Most occurring characters

Value	Count	Frequency (%)
	551349	21.6%
o	428997	16.8%
t	285998	11.2%
l	285998	11.2%
C	142999	5.6%
i	142999	5.6%
y	142999	5.6%
f	142999	5.6%
P	142999	5.6%
a	142999	5.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1572989	61.6%
Space Separator	551349	21.6%
Uppercase Letter	428997	16.8%

Most frequent character per category

Value	Count	Frequency (%)
o	428997	27.3%
t	285998	18.2%
l	285998	18.2%
i	142999	9.1%
y	142999	9.1%
f	142999	9.1%
a	142999	9.1%

Value	Count	Frequency (%)
C	142999	33.3%
P	142999	33.3%
A	142999	33.3%

Value	Count	Frequency (%)
	551349	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2001986	78.4%
Common	551349	21.6%

Most frequent character per script

Value	Count	Frequency (%)
o	428997	21.4%
t	285998	14.3%
l	285998	14.3%
C	142999	7.1%
i	142999	7.1%
y	142999	7.1%
f	142999	7.1%
P	142999	7.1%
a	142999	7.1%
A	142999	7.1%

Value	Count	Frequency (%)
	551349	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2553335	100.0%

Most frequent character per block

Value	Count	Frequency (%)
	551349	21.6%
o	428997	16.8%
t	285998	11.2%
l	285998	11.2%
C	142999	5.6%
i	142999	5.6%
y	142999	5.6%
f	142999	5.6%
P	142999	5.6%
a	142999	5.6%

Start Date
Date

Distinct	136299
Distinct (%)	95.3%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Minimum	2011-07-29 20:17:00
Maximum	2017-12-31 23:35:00

Histogram

Histogram with fixed size bins (bins=50)

Start Time Zone
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.2 MiB

PDT	94497
PST	48482
UTC	20

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	428997
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PDT
2nd row	PDT
3rd row	PDT
4th row	PDT
5th row	PDT

Value	Count	Frequency (%)
PDT	94497	66.1%
PST	48482	33.9%
UTC	20	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
pdt	94497	66.1%
pst	48482	33.9%
utc	20	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
T	142999	33.3%
P	142979	33.3%
D	94497	22.0%
S	48482	11.3%
U	20	< 0.1%
C	20	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	428997	100.0%

Most frequent character per category

Value	Count	Frequency (%)
T	142999	33.3%
P	142979	33.3%
D	94497	22.0%
S	48482	11.3%
U	20	< 0.1%
C	20	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	428997	100.0%

Most frequent character per script

Value	Count	Frequency (%)
T	142999	33.3%
P	142979	33.3%
D	94497	22.0%
S	48482	11.3%
U	20	< 0.1%
C	20	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	428997	100.0%

Most frequent character per block

Value	Count	Frequency (%)
T	142999	33.3%
P	142979	33.3%
D	94497	22.0%
S	48482	11.3%
U	20	< 0.1%
C	20	< 0.1%

End Date
Date

Distinct	135841
Distinct (%)	95.0%
Missing	38
Missing (%)	< 0.1%
Memory size	1.1 MiB

Minimum	2011-07-29 23:20:00
Maximum	2018-01-01 07:18:00

Histogram

Histogram with fixed size bins (bins=50)

End Time Zone
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.2 MiB

PDT	94523
PST	48475
UTC	1

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	428997
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	PDT
2nd row	PDT
3rd row	PDT
4th row	PDT
5th row	PDT

Value	Count	Frequency (%)
PDT	94523	66.1%
PST	48475	33.9%
UTC	1	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
pdt	94523	66.1%
pst	48475	33.9%
utc	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
T	142999	33.3%
P	142998	33.3%
D	94523	22.0%
S	48475	11.3%
U	1	< 0.1%
C	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	428997	100.0%

Most frequent character per category

Value	Count	Frequency (%)
T	142999	33.3%
P	142998	33.3%
D	94523	22.0%
S	48475	11.3%
U	1	< 0.1%
C	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	428997	100.0%

Most frequent character per script

Value	Count	Frequency (%)
T	142999	33.3%
P	142998	33.3%
D	94523	22.0%
S	48475	11.3%
U	1	< 0.1%
C	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	428997	100.0%

Most frequent character per block

Value	Count	Frequency (%)
T	142999	33.3%
P	142998	33.3%
D	94523	22.0%
S	48475	11.3%
U	1	< 0.1%
C	1	< 0.1%

Total Duration (hh:mm:ss)
Date

Distinct	27265
Distinct (%)	19.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Minimum	1900-01-01 00:01:00
Maximum	1900-01-01 23:57:22

Histogram

Histogram with fixed size bins (bins=50)

Charging Time (hh:mm:ss)
Date

Distinct	19102
Distinct (%)	13.4%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Minimum	1900-01-01 00:00:00
Maximum	1900-01-01 22:55:55

Histogram

Histogram with fixed size bins (bins=50)

Energy (kWh)
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	105568
Distinct (%)	73.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8.174862756
Minimum	0
Maximum	82.521561
Zeros	27
Zeros (%)	< 0.1%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0.833938
Q1	3.559181
median	6.84
Q3	11.197
95-th percentile	18.7446907
Maximum	82.521561
Range	82.521561
Interquartile range (IQR)	7.637819

Descriptive statistics

Standard deviation	6.679053777
Coefficient of variation (CV)	0.8170233527
Kurtosis	14.47341647
Mean	8.174862756
Median Absolute Deviation (MAD)	3.722037
Skewness	2.659437342
Sum	1168997.199
Variance	44.60975936
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1 × 10⁶	31	< 0.1%
0	27	< 0.1%
3 × 10⁶	22	< 0.1%
0.008	20	< 0.1%
4 × 10⁶	19	< 0.1%
7 × 10⁶	17	< 0.1%
2 × 10⁶	17	< 0.1%
0.001	16	< 0.1%
6.321	16	< 0.1%
0.002	16	< 0.1%
Other values (105558)	142798	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	27	< 0.1%
1 × 10⁶	31	< 0.1%
2 × 10⁶	17	< 0.1%
3 × 10⁶	22	< 0.1%
4 × 10⁶	19	< 0.1%
5 × 10⁶	13	< 0.1%
6 × 10⁶	13	< 0.1%
7 × 10⁶	17	< 0.1%
8 × 10⁶	16	< 0.1%
9 × 10⁶	10	< 0.1%

Value	Count	Frequency (%)
82.521561	1	< 0.1%
81.99	1	< 0.1%
81.242	1	< 0.1%
80.221703	1	< 0.1%
79.573486	1	< 0.1%
79.36	1	< 0.1%
79.346	1	< 0.1%
79.284973	1	< 0.1%
78.568527	1	< 0.1%
78.543076	1	< 0.1%

GHG Savings (kg)
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	12220
Distinct (%)	8.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.43344222
Minimum	0
Maximum	34.659
Zeros	662
Zeros (%)	0.5%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0.35
Q1	1.495
median	2.873
Q3	4.703
95-th percentile	7.873
Maximum	34.659
Range	34.659
Interquartile range (IQR)	3.208

Descriptive statistics

Standard deviation	2.80520194
Coefficient of variation (CV)	0.8170231971
Kurtosis	14.47338368
Mean	3.43344222
Median Absolute Deviation (MAD)	1.563
Skewness	2.659433303
Sum	490978.804
Variance	7.869157922
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	662	0.5%
0.003	95	0.1%
0.001	90	0.1%
0.004	78	0.1%
1.141	58	< 0.1%
0.002	58	< 0.1%
1.196	54	< 0.1%
1.197	54	< 0.1%
1.162	53	< 0.1%
1.143	52	< 0.1%
Other values (12210)	141745	99.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	662	0.5%
0.001	90	0.1%
0.002	58	< 0.1%
0.003	95	0.1%
0.004	78	0.1%
0.005	49	< 0.1%
0.006	46	< 0.1%
0.007	29	< 0.1%
0.008	32	< 0.1%
0.009	40	< 0.1%

Value	Count	Frequency (%)
34.659	1	< 0.1%
34.436	1	< 0.1%
34.122	1	< 0.1%
33.693	1	< 0.1%
33.421	1	< 0.1%
33.331	1	< 0.1%
33.325	1	< 0.1%
33.3	1	< 0.1%
32.999	1	< 0.1%
32.988	1	< 0.1%

Gasoline Savings (gallons)
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	4999
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.025944503
Minimum	0
Maximum	10.356
Zeros	766
Zeros (%)	0.5%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0.105
Q1	0.447
median	0.858
Q3	1.405
95-th percentile	2.352
Maximum	10.356
Range	10.356
Interquartile range (IQR)	0.958

Descriptive statistics

Standard deviation	0.83822197
Coefficient of variation (CV)	0.8170246708
Kurtosis	14.47342848
Mean	1.025944503
Median Absolute Deviation (MAD)	0.467
Skewness	2.659432661
Sum	146709.038
Variance	0.7026160709
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	766	0.5%
0.001	245	0.2%
0.358	168	0.1%
0.347	157	0.1%
0.36	157	0.1%
0.342	151	0.1%
0.356	150	0.1%
0.364	149	0.1%
0.875	149	0.1%
0.353	148	0.1%
Other values (4989)	140759	98.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	766	0.5%
0.001	245	0.2%
0.002	126	0.1%
0.003	109	0.1%
0.004	104	0.1%
0.005	104	0.1%
0.006	87	0.1%
0.007	88	0.1%
0.008	72	0.1%
0.009	77	0.1%

Value	Count	Frequency (%)
10.356	1	< 0.1%
10.29	1	< 0.1%
10.196	1	< 0.1%
10.068	1	< 0.1%
9.986	1	< 0.1%
9.96	1	< 0.1%
9.958	1	< 0.1%
9.95	1	< 0.1%
9.86	1	< 0.1%
9.857	1	< 0.1%

Port Type
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.7 MiB

Level 2	138269
Level 1	4730

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	1000993
Distinct characters	7
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Level 2
2nd row	Level 2
3rd row	Level 2
4th row	Level 2
5th row	Level 2

Value	Count	Frequency (%)
Level 2	138269	96.7%
Level 1	4730	3.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
level	142999	50.0%
2	138269	48.3%
1	4730	1.7%

Most occurring characters

Value	Count	Frequency (%)
e	285998	28.6%
L	142999	14.3%
v	142999	14.3%
l	142999	14.3%
	142999	14.3%
2	138269	13.8%
1	4730	0.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	571996	57.1%
Uppercase Letter	142999	14.3%
Space Separator	142999	14.3%
Decimal Number	142999	14.3%

Most frequent character per category

Value	Count	Frequency (%)
e	285998	50.0%
v	142999	25.0%
l	142999	25.0%

Value	Count	Frequency (%)
2	138269	96.7%
1	4730	3.3%

Value	Count	Frequency (%)
L	142999	100.0%

Value	Count	Frequency (%)
	142999	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	714995	71.4%
Common	285998	28.6%

Most frequent character per script

Value	Count	Frequency (%)
e	285998	40.0%
L	142999	20.0%
v	142999	20.0%
l	142999	20.0%

Value	Count	Frequency (%)
	142999	50.0%
2	138269	48.3%
1	4730	1.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1000993	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	285998	28.6%
L	142999	14.3%
v	142999	14.3%
l	142999	14.3%
	142999	14.3%
2	138269	13.8%
1	4730	0.5%

Port Number
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.9 MiB

2	90258
1	52741

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	142999
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	2
3rd row	2
4th row	2
5th row	2

Value	Count	Frequency (%)
2	90258	63.1%
1	52741	36.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
2	90258	63.1%
1	52741	36.9%

Most occurring characters

Value	Count	Frequency (%)
2	90258	63.1%
1	52741	36.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	142999	100.0%

Most frequent character per category

Value	Count	Frequency (%)
2	90258	63.1%
1	52741	36.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	142999	100.0%

Most frequent character per script

Value	Count	Frequency (%)
2	90258	63.1%
1	52741	36.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	142999	100.0%

Most frequent character per block

Value	Count	Frequency (%)
2	90258	63.1%
1	52741	36.9%

Plug Type
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.5 MiB

J1772	138269
NEMA 5-20R	4730

Length

Max length	10
Median length	5
Mean length	5.165385772
Min length	5

Characters and Unicode

Total characters	738645
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	J1772
2nd row	J1772
3rd row	J1772
4th row	J1772
5th row	J1772

Value	Count	Frequency (%)
J1772	138269	96.7%
NEMA 5-20R	4730	3.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
j1772	138269	93.6%
5-20r	4730	3.2%
nema	4730	3.2%

Most occurring characters

Value	Count	Frequency (%)
7	276538	37.4%
2	142999	19.4%
J	138269	18.7%
1	138269	18.7%
N	4730	0.6%
E	4730	0.6%
M	4730	0.6%
A	4730	0.6%
	4730	0.6%
5	4730	0.6%
Other values (3)	14190	1.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	567266	76.8%
Uppercase Letter	161919	21.9%
Space Separator	4730	0.6%
Dash Punctuation	4730	0.6%

Most frequent character per category

Value	Count	Frequency (%)
J	138269	85.4%
N	4730	2.9%
E	4730	2.9%
M	4730	2.9%
A	4730	2.9%
R	4730	2.9%

Value	Count	Frequency (%)
7	276538	48.7%
2	142999	25.2%
1	138269	24.4%
5	4730	0.8%
0	4730	0.8%

Value	Count	Frequency (%)
	4730	100.0%

Value	Count	Frequency (%)
-	4730	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	576726	78.1%
Latin	161919	21.9%

Most frequent character per script

Value	Count	Frequency (%)
7	276538	47.9%
2	142999	24.8%
1	138269	24.0%
	4730	0.8%
5	4730	0.8%
-	4730	0.8%
0	4730	0.8%

Value	Count	Frequency (%)
J	138269	85.4%
N	4730	2.9%
E	4730	2.9%
M	4730	2.9%
A	4730	2.9%
R	4730	2.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	738645	100.0%

Most frequent character per block

Value	Count	Frequency (%)
7	276538	37.4%
2	142999	19.4%
J	138269	18.7%
1	138269	18.7%
N	4730	0.6%
E	4730	0.6%
M	4730	0.6%
A	4730	0.6%
	4730	0.6%
5	4730	0.6%
Other values (3)	14190	1.9%

Address 1
Categorical

HIGH CORRELATION

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.7 MiB

250 Hamilton Ave	24802
Bryant St	21356
528 High St	19677
3700 Middlefield Rd	18250
532 Webster St	11683
Other values (12)	47231

Length

Max length	19
Median length	14
Mean length	14.10330142
Min length	9

Characters and Unicode

Total characters	2016758
Distinct characters	41
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	250 Hamilton Ave
2nd row	250 Hamilton Ave
3rd row	250 Hamilton Ave
4th row	250 Hamilton Ave
5th row	250 Hamilton Ave

Value	Count	Frequency (%)
250 Hamilton Ave	24802	17.3%
Bryant St	21356	14.9%
528 High St	19677	13.8%
3700 Middlefield Rd	18250	12.8%
532 Webster St	11683	8.2%
400 Cambridge Ave	11148	7.8%
520 Webster St	8823	6.2%
1213 Newell Rd	7106	5.0%
445 Bryant St	6337	4.4%
275 Cambridge Ave	5482	3.8%
Other values (7)	8335	5.8%

Histogram of lengths of the category

Value	Count	Frequency (%)
st	70259	17.2%
ave	41432	10.2%
bryant	27693	6.8%
rd	25356	6.2%
250	24802	6.1%
hamilton	24802	6.1%
528	21683	5.3%
high	21683	5.3%
webster	20854	5.1%
3700	18250	4.5%
Other values (16)	110827	27.2%

Most occurring characters

Value	Count	Frequency (%)
	264642	13.1%
e	150511	7.5%
t	149560	7.4%
i	99615	4.9%
0	96939	4.8%
d	96736	4.8%
5	85487	4.2%
2	83749	4.2%
l	81466	4.0%
a	75077	3.7%
Other values (31)	832976	41.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1070008	53.1%
Decimal Number	397281	19.7%
Uppercase Letter	283648	14.1%
Space Separator	264642	13.1%
Other Punctuation	831	< 0.1%
Dash Punctuation	348	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
e	150511	14.1%
t	149560	14.0%
i	99615	9.3%
d	96736	9.0%
l	81466	7.6%
a	75077	7.0%
r	71158	6.7%
n	58447	5.5%
m	41432	3.9%
v	41432	3.9%
Other values (10)	204574	19.1%

Value	Count	Frequency (%)
S	69084	24.4%
H	45310	16.0%
A	41432	14.6%
B	27693	9.8%
W	26806	9.5%
R	25356	8.9%
M	18250	6.4%
C	16659	5.9%
N	7106	2.5%
D	5952	2.1%

Value	Count	Frequency (%)
0	96939	24.4%
5	85487	21.5%
2	83749	21.1%
3	37409	9.4%
4	25970	6.5%
7	23732	6.0%
1	22312	5.6%
8	21683	5.5%

Value	Count	Frequency (%)
	264642	100.0%

Value	Count	Frequency (%)
-	348	100.0%

Value	Count	Frequency (%)
.	831	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1353656	67.1%
Common	663102	32.9%

Most frequent character per script

Value	Count	Frequency (%)
e	150511	11.1%
t	149560	11.0%
i	99615	7.4%
d	96736	7.1%
l	81466	6.0%
a	75077	5.5%
r	71158	5.3%
S	69084	5.1%
n	58447	4.3%
H	45310	3.3%
Other values (20)	456692	33.7%

Value	Count	Frequency (%)
	264642	39.9%
0	96939	14.6%
5	85487	12.9%
2	83749	12.6%
3	37409	5.6%
4	25970	3.9%
7	23732	3.6%
1	22312	3.4%
8	21683	3.3%
.	831	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2016758	100.0%

Most frequent character per block

Value	Count	Frequency (%)
	264642	13.1%
e	150511	7.5%
t	149560	7.4%
i	99615	4.9%
0	96939	4.8%
d	96736	4.8%
5	85487	4.2%
2	83749	4.2%
l	81466	4.0%
a	75077	3.7%
Other values (31)	832976	41.3%

City
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.0 MiB

Palo Alto	142999

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	1286991
Distinct characters	7
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Palo Alto
2nd row	Palo Alto
3rd row	Palo Alto
4th row	Palo Alto
5th row	Palo Alto

Value	Count	Frequency (%)
Palo Alto	142999	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
palo	142999	50.0%
alto	142999	50.0%

Most occurring characters

Value	Count	Frequency (%)
l	285998	22.2%
o	285998	22.2%
P	142999	11.1%
a	142999	11.1%
	142999	11.1%
A	142999	11.1%
t	142999	11.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	857994	66.7%
Uppercase Letter	285998	22.2%
Space Separator	142999	11.1%

Most frequent character per category

Value	Count	Frequency (%)
l	285998	33.3%
o	285998	33.3%
a	142999	16.7%
t	142999	16.7%

Value	Count	Frequency (%)
P	142999	50.0%
A	142999	50.0%

Value	Count	Frequency (%)
	142999	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1143992	88.9%
Common	142999	11.1%

Most frequent character per script

Value	Count	Frequency (%)
l	285998	25.0%
o	285998	25.0%
P	142999	12.5%
a	142999	12.5%
A	142999	12.5%
t	142999	12.5%

Value	Count	Frequency (%)
	142999	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1286991	100.0%

Most frequent character per block

Value	Count	Frequency (%)
l	285998	22.2%
o	285998	22.2%
P	142999	11.1%
a	142999	11.1%
	142999	11.1%
A	142999	11.1%
t	142999	11.1%

State/Province
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.1 MiB

California	142999

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	1429990
Distinct characters	8
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	California
2nd row	California
3rd row	California
4th row	California
5th row	California

Value	Count	Frequency (%)
California	142999	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
california	142999	100.0%

Most occurring characters

Value	Count	Frequency (%)
a	285998	20.0%
i	285998	20.0%
C	142999	10.0%
l	142999	10.0%
f	142999	10.0%
o	142999	10.0%
r	142999	10.0%
n	142999	10.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1286991	90.0%
Uppercase Letter	142999	10.0%

Most frequent character per category

Value	Count	Frequency (%)
a	285998	22.2%
i	285998	22.2%
l	142999	11.1%
f	142999	11.1%
o	142999	11.1%
r	142999	11.1%
n	142999	11.1%

Value	Count	Frequency (%)
C	142999	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1429990	100.0%

Most frequent character per script

Value	Count	Frequency (%)
a	285998	20.0%
i	285998	20.0%
C	142999	10.0%
l	142999	10.0%
f	142999	10.0%
o	142999	10.0%
r	142999	10.0%
n	142999	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1429990	100.0%

Most frequent character per block

Value	Count	Frequency (%)
a	285998	20.0%
i	285998	20.0%
C	142999	10.0%
l	142999	10.0%
f	142999	10.0%
o	142999	10.0%
r	142999	10.0%
n	142999	10.0%

Postal Code
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.5 MiB

94301	95061
94303	31308
94306	16630

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	714995
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	94301
2nd row	94301
3rd row	94301
4th row	94301
5th row	94301

Value	Count	Frequency (%)
94301	95061	66.5%
94303	31308	21.9%
94306	16630	11.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
94301	95061	66.5%
94303	31308	21.9%
94306	16630	11.6%

Most occurring characters

Value	Count	Frequency (%)
3	174307	24.4%
9	142999	20.0%
4	142999	20.0%
0	142999	20.0%
1	95061	13.3%
6	16630	2.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	714995	100.0%

Most frequent character per category

Value	Count	Frequency (%)
3	174307	24.4%
9	142999	20.0%
4	142999	20.0%
0	142999	20.0%
1	95061	13.3%
6	16630	2.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	714995	100.0%

Most frequent character per script

Value	Count	Frequency (%)
3	174307	24.4%
9	142999	20.0%
4	142999	20.0%
0	142999	20.0%
1	95061	13.3%
6	16630	2.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	714995	100.0%

Most frequent character per block

Value	Count	Frequency (%)
3	174307	24.4%
9	142999	20.0%
4	142999	20.0%
0	142999	20.0%
1	95061	13.3%
6	16630	2.3%

Country
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.5 MiB

United States	142999

Length

Max length	13
Median length	13
Mean length	13
Min length	13

Characters and Unicode

Total characters	1858987
Distinct characters	10
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	United States
2nd row	United States
3rd row	United States
4th row	United States
5th row	United States

Value	Count	Frequency (%)
United States	142999	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
states	142999	50.0%
united	142999	50.0%

Most occurring characters

Value	Count	Frequency (%)
t	428997	23.1%
e	285998	15.4%
U	142999	7.7%
n	142999	7.7%
i	142999	7.7%
d	142999	7.7%
	142999	7.7%
S	142999	7.7%
a	142999	7.7%
s	142999	7.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1429990	76.9%
Uppercase Letter	285998	15.4%
Space Separator	142999	7.7%

Most frequent character per category

Value	Count	Frequency (%)
t	428997	30.0%
e	285998	20.0%
n	142999	10.0%
i	142999	10.0%
d	142999	10.0%
a	142999	10.0%
s	142999	10.0%

Value	Count	Frequency (%)
U	142999	50.0%
S	142999	50.0%

Value	Count	Frequency (%)
	142999	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1715988	92.3%
Common	142999	7.7%

Most frequent character per script

Value	Count	Frequency (%)
t	428997	25.0%
e	285998	16.7%
U	142999	8.3%
n	142999	8.3%
i	142999	8.3%
d	142999	8.3%
S	142999	8.3%
a	142999	8.3%
s	142999	8.3%

Value	Count	Frequency (%)
	142999	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1858987	100.0%

Most frequent character per block

Value	Count	Frequency (%)
t	428997	23.1%
e	285998	15.4%
U	142999	7.7%
n	142999	7.7%
i	142999	7.7%
d	142999	7.7%
	142999	7.7%
S	142999	7.7%
a	142999	7.7%
s	142999	7.7%

Latitude
Real number (ℝ_≥0)

Distinct	40
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	37.4405362
Minimum	37.422104
Maximum	37.449375
Zeros	0
Zeros (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	37.422104
5-th percentile	37.422123
Q1	37.443127
median	37.444489
Q3	37.446583
95-th percentile	37.448284
Maximum	37.449375
Range	0.027271
Interquartile range (IQR)	0.003456

Descriptive statistics

Standard deviation	0.009351716199
Coefficient of variation (CV)	0.0002497751675
Kurtosis	-0.4264972262
Mean	37.4405362
Median Absolute Deviation (MAD)	0.002094
Skewness	-1.157793992
Sum	5353959.236
Variance	8.745459587 × 10⁵
Monotocity	Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
37.44651	11595	8.1%
37.446613	10822	7.6%
37.444489	10070	7.0%
37.443676	9027	6.3%
37.448284	7935	5.5%
37.445496	7815	5.5%
37.444607	7143	5.0%
37.448238	7132	5.0%
37.443558	6729	4.7%
37.444359	5872	4.1%
Other values (30)	58859	41.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
37.422104	4665	3.3%
37.422119	1242	0.9%
37.422123	4722	3.3%
37.422138	5360	3.7%
37.422146	913	0.6%
37.422169	1348	0.9%
37.426155	4990	3.5%
37.426182	4691	3.3%
37.42733	736	0.5%
37.427349	731	0.5%

Value	Count	Frequency (%)
37.449375	164	0.1%
37.449348	4740	3.3%
37.448284	7935	5.5%
37.448273	912	0.6%
37.448238	7132	5.0%
37.446785	636	0.4%
37.44669	902	0.6%
37.446667	958	0.7%
37.446613	10822	7.6%
37.446583	2616	1.8%

Longitude
Real number (ℝ)

Distinct	43
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-122.1510521
Minimum	-122.163239
Maximum	-122.11248
Zeros	0
Zeros (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	-122.163239
5-th percentile	-122.16288
Q1	-122.16214
median	-122.159904
Q3	-122.144188
95-th percentile	-122.113457
Maximum	-122.11248
Range	0.050759
Interquartile range (IQR)	0.017952

Descriptive statistics

Standard deviation	0.01632732565
Coefficient of variation (CV)	-0.0001336650431
Kurtosis	0.7881561663
Mean	-122.1510521
Median Absolute Deviation (MAD)	0.002404
Skewness	1.458586382
Sum	-17467478.3
Variance	0.0002665815628
Monotocity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
-122.16214	11595	8.1%
-122.162308	10822	7.6%
-122.16037	10070	7.0%
-122.146065	9681	6.8%
-122.16288	9027	6.3%
-122.158272	7576	5.3%
-122.160263	7143	5.0%
-122.158203	7132	5.0%
-122.162849	6729	4.7%
-122.159904	5872	4.1%
Other values (33)	57352	40.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-122.163239	23	< 0.1%
-122.163231	23	< 0.1%
-122.163139	40	< 0.1%
-122.163078	27	< 0.1%
-122.163048	1000	0.7%
-122.163033	2497	1.7%
-122.163017	2317	1.6%
-122.16288	9027	6.3%
-122.162849	6729	4.7%
-122.162369	636	0.4%

Value	Count	Frequency (%)
-122.11248	1348	0.9%
-122.112511	913	0.6%
-122.112556	1242	0.9%
-122.113457	5360	3.7%
-122.113487	4722	3.3%
-122.11351	4665	3.3%
-122.138847	637	0.4%
-122.138863	3849	2.7%
-122.138893	3467	2.4%
-122.138924	3966	2.8%

Currency
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.2 MiB

USD	142990
MXN	5
EUR	3
CAD	1

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	428997
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	USD
2nd row	USD
3rd row	USD
4th row	USD
5th row	USD

Value	Count	Frequency (%)
USD	142990	> 99.9%
MXN	5	< 0.1%
EUR	3	< 0.1%
CAD	1	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
usd	142990	> 99.9%
mxn	5	< 0.1%
eur	3	< 0.1%
cad	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
U	142993	33.3%
D	142991	33.3%
S	142990	33.3%
M	5	< 0.1%
X	5	< 0.1%
N	5	< 0.1%
E	3	< 0.1%
R	3	< 0.1%
C	1	< 0.1%
A	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	428997	100.0%

Most frequent character per category

Value	Count	Frequency (%)
U	142993	33.3%
D	142991	33.3%
S	142990	33.3%
M	5	< 0.1%
X	5	< 0.1%
N	5	< 0.1%
E	3	< 0.1%
R	3	< 0.1%
C	1	< 0.1%
A	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	428997	100.0%

Most frequent character per script

Value	Count	Frequency (%)
U	142993	33.3%
D	142991	33.3%
S	142990	33.3%
M	5	< 0.1%
X	5	< 0.1%
N	5	< 0.1%
E	3	< 0.1%
R	3	< 0.1%
C	1	< 0.1%
A	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	428997	100.0%

Most frequent character per block

Value	Count	Frequency (%)
U	142993	33.3%
D	142991	33.3%
S	142990	33.3%
M	5	< 0.1%
X	5	< 0.1%
N	5	< 0.1%
E	3	< 0.1%
R	3	< 0.1%
C	1	< 0.1%
A	1	< 0.1%

Fee
Real number (ℝ_≥0)

ZEROS

Distinct	886
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.2200582522
Minimum	0
Maximum	79.94
Zeros	127421
Zeros (%)	89.1%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1.74
Maximum	79.94
Range	79.94
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.9127005777
Coefficient of variation (CV)	4.147540793
Kurtosis	604.2019228
Mean	0.2200582522
Median Absolute Deviation (MAD)	0
Skewness	13.59793344
Sum	31468.11
Variance	0.8330223445
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	127421	89.1%
1.46	89	0.1%
1.43	84	0.1%
1.47	83	0.1%
1.4	82	0.1%
1.42	80	0.1%
1.41	79	0.1%
1.45	79	0.1%
1.44	75	0.1%
1.53	71	< 0.1%
Other values (876)	14856	10.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	127421	89.1%
0.01	12	< 0.1%
0.02	7	< 0.1%
0.03	14	< 0.1%
0.04	18	< 0.1%
0.05	16	< 0.1%
0.06	28	< 0.1%
0.07	27	< 0.1%
0.08	34	< 0.1%
0.09	27	< 0.1%

Value	Count	Frequency (%)
79.94	1	< 0.1%
47.56	1	< 0.1%
44.2	1	< 0.1%
31.69	1	< 0.1%
31.43	1	< 0.1%
28.15	1	< 0.1%
27.14	1	< 0.1%
24.22	1	< 0.1%
23.71	1	< 0.1%
23.38	1	< 0.1%

Ended By
Categorical

HIGH CORRELATION

Distinct	13
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.0 MiB

Plug Out at Vehicle	107878
Customer	32844
CPS Server	2006
Final GFCI Tripped	64
Door Open	56
Other values (8)	151

Length

Max length	28
Median length	19
Mean length	16.33896741
Min length	3

Characters and Unicode

Total characters	2336456
Distinct characters	37
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Plug Out at Vehicle
2nd row	Customer
3rd row	Plug Out at Vehicle
4th row	Customer
5th row	Plug Out at Vehicle

Value	Count	Frequency (%)
Plug Out at Vehicle	107878	75.4%
Customer	32844	23.0%
CPS Server	2006	1.4%
Final GFCI Tripped	64	< 0.1%
Door Open	56	< 0.1%
Outlet Unreachable	50	< 0.1%
Door	34	< 0.1%
Plug Removed While Rebooting	24	< 0.1%
Unknown	17	< 0.1%
Plug Out at Station	12	< 0.1%
Other values (3)	14	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
plug	107914	23.0%
out	107890	23.0%
at	107890	23.0%
vehicle	107878	23.0%
customer	32844	7.0%
server	2006	0.4%
cps	2006	0.4%
door	90	< 0.1%
final	71	< 0.1%
gfci	71	< 0.1%
Other values (14)	347	0.1%

Most occurring characters

Value	Count	Frequency (%)
	326008	14.0%
e	252990	10.8%
t	248791	10.6%
u	248703	10.6%
l	215997	9.2%
P	109925	4.7%
i	108092	4.6%
a	108073	4.6%
O	107998	4.6%
h	107952	4.6%
Other values (27)	501927	21.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1645102	70.4%
Uppercase Letter	365332	15.6%
Space Separator	326008	14.0%
Decimal Number	7	< 0.1%
Dash Punctuation	7	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
e	252990	15.4%
t	248791	15.1%
u	248703	15.1%
l	215997	13.1%
i	108092	6.6%
a	108073	6.6%
h	107952	6.6%
g	107943	6.6%
c	107928	6.6%
r	37079	2.3%
Other values (10)	101554	6.2%

Value	Count	Frequency (%)
P	109925	30.1%
O	107998	29.6%
V	107878	29.5%
C	34923	9.6%
S	4024	1.1%
F	142	< 0.1%
D	92	< 0.1%
G	71	< 0.1%
I	71	< 0.1%
U	67	< 0.1%
Other values (4)	141	< 0.1%

Value	Count	Frequency (%)
	326008	100.0%

Value	Count	Frequency (%)
4	7	100.0%

Value	Count	Frequency (%)
-	7	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2010434	86.0%
Common	326022	14.0%

Most frequent character per script

Value	Count	Frequency (%)
e	252990	12.6%
t	248791	12.4%
u	248703	12.4%
l	215997	10.7%
P	109925	5.5%
i	108092	5.4%
a	108073	5.4%
O	107998	5.4%
h	107952	5.4%
g	107943	5.4%
Other values (24)	393970	19.6%

Value	Count	Frequency (%)
	326008	> 99.9%
4	7	< 0.1%
-	7	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2336456	100.0%

Most frequent character per block

Value	Count	Frequency (%)
	326008	14.0%
e	252990	10.8%
t	248791	10.6%
u	248703	10.6%
l	215997	9.2%
P	109925	4.7%
i	108092	4.6%
a	108073	4.6%
O	107998	4.6%
h	107952	4.6%
Other values (27)	501927	21.5%

Plug In Event Id
Real number (ℝ_≥0)

Distinct	24117
Distinct (%)	16.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	118419607
Minimum	1
Maximum	1514779105
Zeros	0
Zeros (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	1
5-th percentile	239
Q1	1294
median	3136
Q3	5623
95-th percentile	1466483068
Maximum	1514779105
Range	1514779104
Interquartile range (IQR)	4329

Descriptive statistics

Standard deviation	400359258.3
Coefficient of variation (CV)	3.380852787
Kurtosis	7.536082849
Mean	118419607
Median Absolute Deviation (MAD)	2053
Skewness	3.086996533
Sum	1.693388538 × 10¹³
Variance	1.602875357 × 10¹⁷
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
657	217	0.2%
432	37	< 0.1%
345	36	< 0.1%
319	36	< 0.1%
140	36	< 0.1%
286	36	< 0.1%
460	36	< 0.1%
532	35	< 0.1%
371	35	< 0.1%
362	35	< 0.1%
Other values (24107)	142460	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	5	< 0.1%
2	9	< 0.1%
3	9	< 0.1%
4	14	< 0.1%
5	14	< 0.1%
6	17	< 0.1%
7	19	< 0.1%
8	16	< 0.1%
9	20	< 0.1%
10	18	< 0.1%

Value	Count	Frequency (%)
1514779105	1	< 0.1%
1514764157	1	< 0.1%
1514751111	1	< 0.1%
1514749571	1	< 0.1%
1514744337	1	< 0.1%
1514736612	1	< 0.1%
1514682008	1	< 0.1%
1514681702	1	< 0.1%
1514681058	1	< 0.1%
1514672881	1	< 0.1%

Driver Postal Code
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

Park Duration (mins)
Categorical

HIGH CARDINALITY

Distinct	1217
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	8.4 MiB

2	767
182	719
181	702
176	683
183	681
Other values (1212)	139447

Length

Max length	8
Median length	5
Mean length	4.613018273
Min length	3

Characters and Unicode

Total characters	659657
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	192 ?
Unique (%)	0.1%

Sample

1st row	184
2nd row	2
3rd row	258
4th row	123
5th row	71

Value	Count	Frequency (%)
2	767	0.5%
182	719	0.5%
181	702	0.5%
176	683	0.5%
183	681	0.5%
179	678	0.5%
177	676	0.5%
101	669	0.5%
66	665	0.5%
73	658	0.5%
Other values (1207)	136101	95.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
2	767	0.5%
182	719	0.5%
181	702	0.5%
176	683	0.5%
183	681	0.5%
179	678	0.5%
177	676	0.5%
101	669	0.5%
66	665	0.5%
73	658	0.5%
Other values (1207)	136101	95.2%

Most occurring characters

Value	Count	Frequency (%)
	285998	43.4%
1	87570	13.3%
2	49658	7.5%
3	32953	5.0%
5	30322	4.6%
7	30145	4.6%
6	30069	4.6%
4	30053	4.6%
8	29306	4.4%
9	27238	4.1%
Other values (2)	26345	4.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	373353	56.6%
Space Separator	285998	43.4%
Other Punctuation	306	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
1	87570	23.5%
2	49658	13.3%
3	32953	8.8%
5	30322	8.1%
7	30145	8.1%
6	30069	8.1%
4	30053	8.0%
8	29306	7.8%
9	27238	7.3%
0	26039	7.0%

Value	Count	Frequency (%)
	285998	100.0%

Value	Count	Frequency (%)
,	306	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	659657	100.0%

Most frequent character per script

Value	Count	Frequency (%)
	285998	43.4%
1	87570	13.3%
2	49658	7.5%
3	32953	5.0%
5	30322	4.6%
7	30145	4.6%
6	30069	4.6%
4	30053	4.6%
8	29306	4.4%
9	27238	4.1%
Other values (2)	26345	4.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	659657	100.0%

Most frequent character per block

Value	Count	Frequency (%)
	285998	43.4%
1	87570	13.3%
2	49658	7.5%
3	32953	5.0%
5	30322	4.6%
7	30145	4.6%
6	30069	4.6%
4	30053	4.6%
8	29306	4.4%
9	27238	4.1%
Other values (2)	26345	4.0%

Charge Duration (mins)
Real number (ℝ_≥0)

Distinct	775
Distinct (%)	0.5%
Missing	14
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	121.5628283
Minimum	0
Maximum	972
Zeros	697
Zeros (%)	0.5%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	15
Q1	64
median	112
Q3	167
95-th percentile	251
Maximum	972
Range	972
Interquartile range (IQR)	103

Descriptive statistics

Standard deviation	81.64789703
Coefficient of variation (CV)	0.671651838
Kurtosis	7.849950593
Mean	121.5628283
Median Absolute Deviation (MAD)	51
Skewness	1.71271298
Sum	17381661
Variance	6666.37909
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
86	929	0.6%
88	924	0.6%
1	922	0.6%
85	914	0.6%
87	913	0.6%
89	874	0.6%
84	850	0.6%
83	831	0.6%
132	821	0.6%
130	820	0.6%
Other values (765)	134187	93.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	697	0.5%
1	922	0.6%
2	590	0.4%
3	421	0.3%
4	332	0.2%
5	388	0.3%
6	358	0.3%
7	412	0.3%
8	377	0.3%
9	367	0.3%

Value	Count	Frequency (%)
972	1	< 0.1%
967	1	< 0.1%
940	1	< 0.1%
932	1	< 0.1%
925	2	< 0.1%
923	1	< 0.1%
911	1	< 0.1%
906	1	< 0.1%
902	1	< 0.1%
891	1	< 0.1%

ID
Real number (ℝ_≥0)

ZEROS

Distinct	55
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	21.55533255
Minimum	0
Maximum	54
Zeros	10712
Zeros (%)	7.5%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	4
median	23
Q3	35
95-th percentile	44
Maximum	54
Range	54
Interquartile range (IQR)	31

Descriptive statistics

Standard deviation	15.45231679
Coefficient of variation (CV)	0.7168674737
Kurtosis	-1.366341342
Mean	21.55533255
Median Absolute Deviation (MAD)	14
Skewness	-0.05956427579
Sum	3082391
Variance	238.7740943
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10712	7.5%
1	9759	6.8%
4	7866	5.5%
2	6820	4.8%
34	5871	4.1%
35	5721	4.0%
32	5544	3.9%
38	5482	3.8%
5	5477	3.8%
37	5427	3.8%
Other values (45)	74320	52.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	10712	7.5%
1	9759	6.8%
2	6820	4.8%
3	2741	1.9%
4	7866	5.5%
5	5477	3.8%
6	857	0.6%
7	1599	1.1%
8	495	0.3%
9	252	0.2%

Value	Count	Frequency (%)
54	24	< 0.1%
53	4	< 0.1%
52	456	0.3%
51	620	0.4%
50	842	0.6%
49	1088	0.8%
48	899	0.6%
47	902	0.6%
46	636	0.4%
45	958	0.7%

Pairlocation
Categorical

HIGH CORRELATION

Distinct	44
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.6 MiB

37.44651x-122.16214	11595
37.446613x-122.162308	10822
37.444489x-122.16037	10070
37.443676x-122.16288	9027
37.448284x-122.158272	7576
Other values (39)	93909

Length

Max length	21
Median length	21
Mean length	20.63044497
Min length	18

Characters and Unicode

Total characters	2950133
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	37.444572x-122.160309
2nd row	37.444572x-122.160309
3rd row	37.444572x-122.160309
4th row	37.444572x-122.160309
5th row	37.444572x-122.160309

Value	Count	Frequency (%)
37.44651x-122.16214	11595	8.1%
37.446613x-122.162308	10822	7.6%
37.444489x-122.16037	10070	7.0%
37.443676x-122.16288	9027	6.3%
37.448284x-122.158272	7576	5.3%
37.444607x-122.160263	7143	5.0%
37.448238x-122.158203	7132	5.0%
37.443558x-122.162849	6729	4.7%
37.444359x-122.159904	5872	4.1%
37.428318x-122.144188	5482	3.8%
Other values (34)	61551	43.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
37.44651x-122.16214	11595	8.1%
37.446613x-122.162308	10822	7.6%
37.444489x-122.16037	10070	7.0%
37.443676x-122.16288	9027	6.3%
37.448284x-122.158272	7576	5.3%
37.444607x-122.160263	7143	5.0%
37.448238x-122.158203	7132	5.0%
37.443558x-122.162849	6729	4.7%
37.444359x-122.159904	5872	4.1%
37.428318x-122.144188	5482	3.8%
Other values (34)	61551	43.0%

Most occurring characters

Value	Count	Frequency (%)
2	452464	15.3%
1	397647	13.5%
4	385803	13.1%
3	302400	10.3%
.	285998	9.7%
7	210890	7.1%
6	197155	6.7%
8	172980	5.9%
x	142999	4.8%
-	142999	4.8%
Other values (3)	258798	8.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2378137	80.6%
Other Punctuation	285998	9.7%
Lowercase Letter	142999	4.8%
Dash Punctuation	142999	4.8%

Most frequent character per category

Value	Count	Frequency (%)
2	452464	19.0%
1	397647	16.7%
4	385803	16.2%
3	302400	12.7%
7	210890	8.9%
6	197155	8.3%
8	172980	7.3%
5	109346	4.6%
9	75033	3.2%
0	74419	3.1%

Value	Count	Frequency (%)
.	285998	100.0%

Value	Count	Frequency (%)
x	142999	100.0%

Value	Count	Frequency (%)
-	142999	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2807134	95.2%
Latin	142999	4.8%

Most frequent character per script

Value	Count	Frequency (%)
2	452464	16.1%
1	397647	14.2%
4	385803	13.7%
3	302400	10.8%
.	285998	10.2%
7	210890	7.5%
6	197155	7.0%
8	172980	6.2%
-	142999	5.1%
5	109346	3.9%
Other values (2)	149452	5.3%

Value	Count	Frequency (%)
x	142999	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2950133	100.0%

Most frequent character per block

Value	Count	Frequency (%)
2	452464	15.3%
1	397647	13.5%
4	385803	13.1%
3	302400	10.3%
.	285998	9.7%
7	210890	7.1%
6	197155	6.7%
8	172980	5.9%
x	142999	4.8%
-	142999	4.8%
Other values (3)	258798	8.8%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Station Name	MAC Address	Org Name	Start Date	Start Time Zone	End Date	End Time Zone	Total Duration (hh:mm:ss)	Charging Time (hh:mm:ss)	Energy (kWh)	GHG Savings (kg)	Gasoline Savings (gallons)	Port Type	Port Number	Plug Type	Address 1	City	State/Province	Postal Code	Country	Latitude	Longitude	Currency	Ended By	Plug In Event Id	Driver Postal Code	Park Duration (mins)	Charge Duration (mins)	Pairlocation
0	PALO ALTO CA / HAMILTON #1	000D:6F00:015A:9D76	City of Palo Alto	2011-07-29 20:17:00	PDT	2011-07-29 23:20:00	PDT	1900-01-01 03:03:32	1900-01-01 01:54:03	6.249457	2.625	0.784	Level 2	2	J1772	250 Hamilton Ave	Palo Alto	California	94301	United States	37.444572	-122.160309	USD	Plug Out at Vehicle	3	95124.0	184	114.0	37.444572x-122.160309
1	PALO ALTO CA / HAMILTON #1	000D:6F00:015A:9D76	City of Palo Alto	2011-07-30 00:00:00	PDT	2011-07-30 00:02:00	PDT	1900-01-01 00:02:06	1900-01-01 00:01:54	0.106588	0.045	0.013	Level 2	2	J1772	250 Hamilton Ave	Palo Alto	California	94301	United States	37.444572	-122.160309	USD	Customer	4	94301.0	2	2.0	37.444572x-122.160309
2	PALO ALTO CA / HAMILTON #1	000D:6F00:015A:9D76	City of Palo Alto	2011-07-30 08:16:00	PDT	2011-07-30 12:34:00	PDT	1900-01-01 04:17:32	1900-01-01 04:17:28	14.951777	6.280	1.876	Level 2	2	J1772	250 Hamilton Ave	Palo Alto	California	94301	United States	37.444572	-122.160309	USD	Plug Out at Vehicle	5	94301.0	258	257.0	37.444572x-122.160309
3	PALO ALTO CA / HAMILTON #1	000D:6F00:015A:9D76	City of Palo Alto	2011-07-30 14:51:00	PDT	2011-07-30 16:55:00	PDT	1900-01-01 02:03:24	1900-01-01 02:02:58	7.159643	3.007	0.899	Level 2	2	J1772	250 Hamilton Ave	Palo Alto	California	94301	United States	37.444572	-122.160309	USD	Customer	6	94302.0	123	123.0	37.444572x-122.160309
4	PALO ALTO CA / HAMILTON #1	000D:6F00:015A:9D76	City of Palo Alto	2011-07-30 18:51:00	PDT	2011-07-30 20:03:00	PDT	1900-01-01 01:11:24	1900-01-01 00:43:54	1.957765	0.822	0.246	Level 2	2	J1772	250 Hamilton Ave	Palo Alto	California	94301	United States	37.444572	-122.160309	USD	Plug Out at Vehicle	7	94043.0	71	44.0	37.444572x-122.160309
5	PALO ALTO CA / HAMILTON #1	000D:6F00:015A:9D76	City of Palo Alto	2011-07-31 04:33:00	PDT	2011-07-31 10:40:00	PDT	1900-01-01 06:06:19	1900-01-01 04:56:47	17.171463	7.212	2.155	Level 2	2	J1772	250 Hamilton Ave	Palo Alto	California	94301	United States	37.444572	-122.160309	USD	Customer	9	94301.0	366	297.0	37.444572x-122.160309
6	PALO ALTO CA / HAMILTON #1	000D:6F00:015A:9D76	City of Palo Alto	2011-07-31 12:25:00	PDT	2011-07-31 13:35:00	PDT	1900-01-01 01:09:54	1900-01-01 01:09:49	3.799148	1.596	0.477	Level 2	2	J1772	250 Hamilton Ave	Palo Alto	California	94301	United States	37.444572	-122.160309	USD	Plug Out at Vehicle	10	94301.0	70	70.0	37.444572x-122.160309
7	PALO ALTO CA / HAMILTON #1	000D:6F00:015A:9D76	City of Palo Alto	2011-07-31 17:41:00	PDT	2011-07-31 22:31:00	PDT	1900-01-01 04:49:46	1900-01-01 04:41:16	16.238552	6.820	2.038	Level 2	2	J1772	250 Hamilton Ave	Palo Alto	California	94301	United States	37.444572	-122.160309	USD	Customer	11	94301.0	290	281.0	37.444572x-122.160309
8	PALO ALTO CA / HAMILTON #1	000D:6F00:015A:9D76	City of Palo Alto	2011-08-01 19:11:00	PDT	2011-08-01 22:34:00	PDT	1900-01-01 03:23:34	1900-01-01 01:35:08	5.041244	2.117	0.633	Level 2	2	J1772	250 Hamilton Ave	Palo Alto	California	94301	United States	37.444572	-122.160309	USD	Plug Out at Vehicle	13	94303.0	204	95.0	37.444572x-122.160309
9	PALO ALTO CA / HAMILTON #1	000D:6F00:015A:9D76	City of Palo Alto	2011-08-02 14:00:00	PDT	2011-08-02 15:13:00	PDT	1900-01-01 01:12:43	1900-01-01 01:12:33	4.197217	1.763	0.527	Level 2	2	J1772	250 Hamilton Ave	Palo Alto	California	94301	United States	37.444572	-122.160309	USD	Plug Out at Vehicle	14	94403.0	73	73.0	37.444572x-122.160309

Last rows

	Station Name	MAC Address	Org Name	Start Date	Start Time Zone	End Date	End Time Zone	Total Duration (hh:mm:ss)	Charging Time (hh:mm:ss)	Energy (kWh)	GHG Savings (kg)	Gasoline Savings (gallons)	Port Type	Port Number	Plug Type	Address 1	City	State/Province	Postal Code	Country	Latitude	Longitude	Currency	Fee	Ended By	Plug In Event Id	Driver Postal Code	Park Duration (mins)	Charge Duration (mins)	ID	Pairlocation
142989	PALO ALTO CA / HIGH #2	0024:B100:0002:5959	City of Palo Alto	2017-12-31 17:33:00	PST	2017-12-31 19:39:00	PST	1900-01-01 02:06:10	1900-01-01 01:47:16	9.394	3.946	1.179	Level 2	2	J1772	528 High St	Palo Alto	California	94301	United States	37.443344	-122.163231	USD	2.16	Customer	2202	94404	126	107.0	42	37.443344x-122.163231
142990	PALO ALTO CA / CAMBRIDGE #1	0024:B100:0002:1329	City of Palo Alto	2017-12-31 17:34:00	PST	2017-12-31 19:17:00	PST	1900-01-01 01:42:07	1900-01-01 01:35:19	5.249	2.205	0.659	Level 2	2	J1772	400 Cambridge Ave	Palo Alto	California	94306	United States	37.426155	-122.146065	USD	1.21	Plug Out at Vehicle	6177	94306	102	95.0	35	37.426155x-122.146065
142991	PALO ALTO CA / WEBSTER #1	0024:B100:0002:4233	City of Palo Alto	2017-12-31 18:19:00	PST	2017-12-31 23:36:00	PST	1900-01-01 05:16:55	1900-01-01 02:35:56	7.928	3.330	0.995	Level 2	2	J1772	520 Webster St	Palo Alto	California	94301	United States	37.448284	-122.158272	USD	5.88	Plug Out at Vehicle	1092	94020	317	156.0	49	37.448284x-122.158272
142992	PALO ALTO CA / CAMBRIDGE #1	0024:B100:0002:1329	City of Palo Alto	2017-12-31 18:22:00	PST	2017-12-31 22:18:00	PST	1900-01-01 03:55:33	1900-01-01 03:55:20	13.412	5.633	1.683	Level 2	1	J1772	400 Cambridge Ave	Palo Alto	California	94306	United States	37.426155	-122.146065	USD	3.08	CPS Server	6178	94043	236	235.0	35	37.426155x-122.146065
142993	PALO ALTO CA / HAMILTON #2	0024:B100:0002:965D	City of Palo Alto	2017-12-31 18:53:00	PST	2017-12-31 21:18:00	PST	1900-01-01 02:24:33	1900-01-01 02:15:06	6.406	2.690	0.804	Level 2	2	J1772	250 Hamilton Ave	Palo Alto	California	94301	United States	37.444706	-122.160324	USD	1.47	Customer	475	94010	145	135.0	52	37.444706x-122.160324
142994	PALO ALTO CA / CAMBRIDGE #2	0024:B100:0002:13B7	City of Palo Alto	2017-12-31 19:58:00	PST	2017-12-31 20:19:00	PST	1900-01-01 00:20:51	1900-01-01 00:20:34	2.063	0.866	0.259	Level 2	2	J1772	400 Cambridge Ave	Palo Alto	California	94306	United States	37.426182	-122.146065	USD	0.47	Plug Out at Vehicle	1514779105	94601	21	21.0	37	37.426182x-122.146065
142995	PALO ALTO CA / BRYANT #5	0024:B100:0002:6D51	City of Palo Alto	2017-12-31 20:20:00	PST	2017-12-31 22:57:00	PST	1900-01-01 02:37:02	1900-01-01 02:36:50	15.681	6.586	1.968	Level 2	2	J1772	445 Bryant St	Palo Alto	California	94301	United States	37.446690	-122.162231	USD	3.61	Plug Out at Vehicle	900	94555	157	157.0	47	37.44669x-122.162231
142996	PALO ALTO CA / HIGH #4	0024:B100:0002:1327	City of Palo Alto	2017-12-31 20:54:00	PST	2017-12-31 22:04:00	PST	1900-01-01 01:09:38	1900-01-01 01:09:21	3.854	1.619	0.484	Level 2	1	J1772	528 High St	Palo Alto	California	94301	United States	37.443138	-122.163239	USD	0.89	Plug Out at Vehicle	1148	94301	70	69.0	44	37.443138x-122.163239
142997	PALO ALTO CA / WEBSTER #2	0024:B100:0002:050E	City of Palo Alto	2017-12-31 21:00:00	PST	2017-12-31 22:56:00	PST	1900-01-01 01:55:17	1900-01-01 01:09:42	2.854	1.199	0.358	Level 2	2	J1772	520 Webster St	Palo Alto	California	94301	United States	37.448238	-122.158203	USD	1.33	Plug Out at Vehicle	864	95070	115	70.0	48	37.448238x-122.158203
142998	PALO ALTO CA / MPL #2	000D:6F00:0154:EF9A	City of Palo Alto	2017-12-31 23:35:00	PST	2018-01-01 07:18:00	PST	1900-01-01 07:42:26	1900-01-01 07:42:13	47.392	19.905	5.948	Level 2	1	J1772	3700 Middlefield Rd	Palo Alto	California	94303	United States	37.422169	-122.112480	USD	10.90	Plug Out at Vehicle	1384	94303	462	462.0	30	37.422169x-122.11248

Most frequent

	Station Name	MAC Address	Org Name	Start Date	Start Time Zone	End Date	End Time Zone	Total Duration (hh:mm:ss)	Charging Time (hh:mm:ss)	Energy (kWh)	GHG Savings (kg)	Gasoline Savings (gallons)	Port Type	Port Number	Plug Type	Address 1	City	State/Province	Postal Code	Country	Latitude	Longitude	Currency	Ended By	Plug In Event Id	Park Duration (mins)	Charge Duration (mins)	ID	Pairlocation	count
0	PALO ALTO CA / BRYANT #2	000D:6F00:009D:CFC3	City of Palo Alto	2017-03-10 14:07:00	PST	2017-03-10 15:53:00	PST	1900-01-01 01:46:01	1900-01-01 01:24:31	4.385000	1.842	0.550	Level 2	2	J1772	Bryant St	Palo Alto	California	94301	United States	37.446510	-122.162140	USD	Customer	9453	106	85.0	20	37.44651x-122.16214	2
1	PALO ALTO CA / HIGH #2	0024:B100:0002:5959	City of Palo Alto	2017-02-27 11:14:00	PST	2017-02-27 14:17:00	PST	1900-01-01 03:02:42	1900-01-01 02:33:45	8.538000	3.586	1.071	Level 2	1	J1772	528 high st	Palo Alto	California	94301	United States	37.443146	-122.163017	USD	Plug Out at Vehicle	1488222853	183	154.0	42	37.443146x-122.163017	2
2	PALO ALTO CA / MPL #6	000D6F00015B7509	City of Palo Alto	2015-02-25 15:24:00	PST	2015-02-25 15:46:00	PST	1900-01-01 00:22:23	1900-01-01 00:22:10	1.186864	0.498	0.149	Level 2	1	J1772	3700 Middlefield Rd	Palo Alto	California	94303	United States	37.422138	-122.113457	USD	Plug Out at Vehicle	469	22	22.0	7	37.422138x-122.113457	2

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters